An Analytical Method for Estimating and Interpreting Query Time
نویسندگان
چکیده
This paper presents a general methodology to decompose the processing of relational queries into functional units. Each unit consumes a constant CPU usage, which depends on the DBMS and system configuration, but not on the database or the query. We describe how to measure the unit CPU consumption, as well as how to use it to predict and interpret query time. Two DBMSs were tested to validate and calibrate the model. Its applications on DBMS design, database &sign, query performance and DBMS comparison are discussed.
منابع مشابه
Investigation of analytical and numerical solutions for one-dimensional independent-oftime Schrödinger Equation
In this paper, the numerical solution methods of one- particale, one – dimensional time- independentSchrodinger equation are presented that allows one to obtain accurate bound state eigen values andeigen functions for an arbitrary potential energy function V(x). These methods included the FEM(Finite Element Method), Cooly, Numerov and others. Here we considered the Numerov method inmore details...
متن کاملQuery Architecture Expansion in Web Using Fuzzy Multi Domain Ontology
Due to the increasing web, there are many challenges to establish a general framework for data mining and retrieving structured data from the Web. Creating an ontology is a step towards solving this problem. The ontology raises the main entity and the concept of any data in data mining. In this paper, we tried to propose a method for applying the "meaning" of the search system, But the problem ...
متن کاملAdaptive Simplified Model Predictive Control with Tuning Considerations
Model predictive controller is widely used in industrial plants. Uncertainty is one of the critical issues in real systems. In this paper, the direct adaptive Simplified Model Predictive Control (SMPC) is proposed for unknown or time varying plants with uncertainties. By estimating the plant step response in each sample, the controller is designed and the controller coefficients are directly ca...
متن کاملA Least Squares Approach to Estimating the Average Reservoir Pressure
Least squares method (LSM) is an accurate and rapid method for solving some analytical and numerical problems. This method can be used to estimate the average reservoir pressure in well test analysis. In fact, it may be employed to estimate parameters such as permeability (k) and pore volume (Vp). Regarding this point, buildup, drawdown, late transient test data, modified Muskat method, interfe...
متن کاملQuery expansion based on relevance feedback and latent semantic analysis
Web search engines are one of the most popular tools on the Internet which are widely-used by expert and novice users. Constructing an adequate query which represents the best specification of users’ information need to the search engine is an important concern of web users. Query expansion is a way to reduce this concern and increase user satisfaction. In this paper, a new method of query expa...
متن کامل